DisplayColumnHeadings Property

Returns or sets whether column headings are displayed in the specified window. Set this property to False to hide the columns headings. The default value is True. Read/write Boolean.

expression   Required. An expression that returns a Window object.

Example

This example hides the row and column headings in the active window of Spreadsheet1.

Sub HideHeadings()
   Spreadsheet1.ActiveWindow.DisplayColumnHeadings = False
   Spreadsheet1.ActiveWindow.DisplayRowHeadings = False
End Sub